package com.isoft.demo01.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.isoft.demo01.entity.Game;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Repository
@Mapper
public interface GameManageDao extends BaseMapper<Game> {
    @Select("select tb_game.*,tb_gametype.typename" +
            "            from tb_game inner join tb_gametype " +
            "            on tb_game.typeid=tb_gametype.typeid " +
            "            where tb_game.gameid=#{gameid}")
    public Game getDetailById(Integer gameid);
}